SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534151 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534151 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (659154,738964,972849,125703,56971,495311,3860,748470,44869,519941,1046621,558507,850362,623469,27413,947445,536056,402037,991627,257875,960312,26030,701789,281260,802822,730954,540266,400948,569450,830266,262510,927090,708864,593401,776278,969275,493230,414911,815890,292291,49497,606989,98637,169276,199009,694115,398352,1005047,71139,692664,975909,763467,788057,987051,876703,622889,621753,665694,863365,443160) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]