SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 245029 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 245029 [ RunTime:0.002478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (381931,986883,921491,483185,516206,187109,980029,300136,859888,380213,984359,392320,12152,438794,103765,894109,164552,129220,805893,386234,689454,250822,652418,562555,167880,1041589,397964,331135,1009204,220664,193675,692006,832111,935213,426477,4072,829245,1000630,108428,443000,63205,46595,232866,926057,1006089,236253,734920,464149,658811,213655,997041,699947,258230,904830,469974,655898,679312,364576,210452,2847) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 245029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 245029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]