SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043006 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043006 [ RunTime:0.004266s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040212,936592,819494,1042475,1016261,223235,3096,383240,377591,55171,39905,161748,899439,982024,35337,435776,935040,796516,688213,994888,954846,887442,204105,377225,674316,471903,784399,658750,709504,65496,354446,60907,2981,521585,390833,644711,844676,536450,561636,929938,890422,71259,133954,68255,575986,823303,492634,159277,1034503,247865,258340,164864,518698,253269,1020811,916949,274603,949904,515574,1031991) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001689s ]