SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 382621 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 382621 [ RunTime:0.002078s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (242978,590912,373713,633149,378941,912350,221435,549165,827965,731702,1048401,1026932,968294,32601,640158,623465,455113,906675,487658,335070,968675,115680,159763,174829,1017187,812941,189817,208183,279348,663150,983070,930706,457657,535792,257183,122723,465583,265261,857913,884890,418271,18994,157188,936718,522101,1025748,371369,11747,69439,1022810,483541,61184,750008,1040185,1045274,281557,419414,924308,763275,879265) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 382621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 382621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]