SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002534s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439470 LIMIT 1 [ RunTime:0.000558s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439470 [ RunTime:0.001832s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (581401,766628,894475,497279,246592,87943,596260,584225,161531,492100,477270,1014992,1010893,977605,827131,737130,63406,47983,61141,350603,152496,845264,1030921,778856,24781,903564,491936,246617,520251,965489,395498,763650,539462,827996,219170,731201,148516,348014,905757,229457,603202,789639,175789,281542,530748,31490,394552,111999,415703,587426,927868,1040625,129004,83089,26789,198544,588149,970149,466796,690147) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]