SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500213 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500213 [ RunTime:0.001686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (232469,675918,290308,519397,804513,407552,404262,667026,888221,894284,752932,569841,206027,210548,199511,913083,722827,791879,689536,514855,672385,786314,861817,847174,929140,248063,954541,53598,562836,504781,405341,411703,1008794,730769,182095,334089,34099,44857,844781,66961,917863,857391,914333,23225,798473,179724,330640,223531,990177,648933,1013656,558954,401318,713216,588300,649871,411024,792045,244427,619346) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]