SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 857117 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 857117 [ RunTime:0.001653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (11672,592889,420695,757554,674291,433967,819933,17465,758359,743877,615879,11645,767226,970841,953724,490237,442236,54338,148589,500333,847656,260333,101854,446673,360589,449763,494613,230320,259293,57541,930738,716462,259043,884880,332547,977197,334742,201030,277789,868169,376280,352521,554889,86162,739987,74205,469590,1028419,31466,101519,262332,748848,35085,808877,710404,528348,53936,773948,250774,532720) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 857117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 857117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]