SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501834 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501834 [ RunTime:0.001997s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (572475,66209,581517,946061,526116,545339,162534,473242,72801,842552,576769,705128,1015222,814499,954357,160208,458587,154007,84258,954938,535655,352810,472778,538438,245533,47488,361063,252964,786223,708532,514564,259840,67935,63583,433336,721179,312988,492151,388064,769200,605830,671903,257003,531670,877273,49215,845715,757050,919047,161543,655977,728430,456761,540224,161153,532397,126724,913188,930941,802166) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]