SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 556730 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 556730 [ RunTime:0.001677s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124788,142833,839654,916463,539038,508975,952201,305697,10669,312112,106571,223925,212235,218547,860300,251979,556924,366268,775086,1025987,352961,977035,196246,331898,927436,627463,443968,267316,428367,329152,564784,824071,587610,577693,507665,786315,923073,281315,925610,876345,884611,483673,116408,314332,116453,720007,689210,156078,677334,826265,465501,30997,890898,271330,209304,920640,381547,86670,858292,686157) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 556730 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 556730 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]