SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 901652 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 901652 [ RunTime:0.001445s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (555522,284748,522549,195891,333947,296986,868321,1042972,927881,341138,1032030,121488,123510,214983,457246,505787,38956,1030570,990196,7072,832284,130121,542092,1006314,155645,969232,6040,90450,30463,224587,1011477,869832,291996,556894,135762,300836,640863,722134,762706,662202,389801,386124,201996,955059,830835,54725,535625,390396,1014599,48903,560561,262448,417277,6886,266287,364796,571830,848080,903433,1010005) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 901652 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 901652 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]