SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485024 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485024 [ RunTime:0.002655s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194414,823704,374287,755141,733167,815762,433241,712106,620150,180026,489172,637217,157564,657301,880675,421275,188407,223438,178593,564231,1037181,1042151,848572,696295,327962,492904,430230,653181,914187,723072,532035,179485,418118,962745,854322,984209,38326,1031008,641326,180552,8431,973972,352145,228818,592630,451468,1009952,242528,582390,280771,391302,687731,44664,385241,84058,967467,537277,689297,403493,266448) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485024 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485024 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]