SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 304913 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 304913 [ RunTime:0.003014s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (587193,232958,207224,212878,199498,609187,173674,520861,561211,645130,931825,198296,488816,741889,972699,304501,61918,402647,92821,28910,356517,251271,698504,400481,712757,915319,952995,63053,999780,876901,358663,709073,216051,893729,136296,732465,196309,903603,319261,393398,375559,9515,16209,719952,3595,961337,195097,24455,890762,273975,964445,27844,811089,701223,941281,459444,258103,623011,391473,245131) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 304913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 304913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]