SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002706s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394746 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394746 [ RunTime:0.005988s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (453384,429273,313153,795548,374369,562771,417219,369814,367686,212201,613459,163856,1034694,327672,974121,91730,516119,867147,44607,659933,368335,194963,223093,422760,77235,758319,973288,245601,26414,302479,145196,798231,795980,162690,1048900,332662,112035,326147,534844,1029818,365607,786877,112660,548346,467767,561947,429982,419121,913522,92947,258468,191237,1033847,32775,415174,579523,1048796,232793,204309,450753) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394746 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394746 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]