SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398151 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398151 [ RunTime:0.001437s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (507687,468371,65926,295963,306927,755172,742140,587353,368680,589434,41325,305119,480808,841373,872262,776262,250960,197512,827159,133015,203590,355244,724862,299239,910628,222175,839325,651317,41541,616919,625727,464683,121994,819424,456218,374453,828224,721783,932396,526802,263483,765159,176531,167154,397487,934492,490459,956422,299264,106529,163817,769452,621147,920787,586830,260481,124596,331665,1007941,94530) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000902s ]