SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509551 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509551 [ RunTime:0.001543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (60724,940147,825318,235326,338337,137544,838998,586274,346239,587387,379856,249562,130274,971074,661851,437069,999710,267286,525500,489126,563959,331575,709545,517187,36123,633702,47945,6164,726511,401530,719061,118560,771859,997614,645358,64718,954532,787998,200379,374651,378660,476683,332080,482025,676503,467045,1028052,802359,28898,737089,965190,889668,775696,809073,190881,407808,139012,421861,720461,208668) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.013494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001793s ]