SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502950 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502950 [ RunTime:0.001722s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (551727,1008050,148249,509361,594542,171991,945665,194938,880437,1008470,656587,107191,928322,459209,598464,16204,898038,845594,409102,588599,313540,153473,510497,1005378,269506,719713,1027586,810707,319906,466605,817554,73007,68062,944175,707521,802931,952932,228068,694340,994265,454691,158789,37515,166879,971166,686715,952741,4923,773131,873192,772086,1026107,228893,267438,486309,913639,480817,465777,119208,308774) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502950 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502950 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]