SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508364 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508364 [ RunTime:0.001791s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (255710,111243,846765,835169,432697,962871,1004603,142714,274344,233467,906090,934485,60783,874889,907906,192299,952345,866068,970092,197579,774122,203310,189625,690757,861690,415422,644151,6954,789580,512536,709549,477474,784505,724502,662558,609610,63874,801792,24302,446594,641289,443147,732602,209899,440175,661340,1538,31700,836730,788767,940053,950605,659380,993586,105489,1014018,937887,680513,160481,834038) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508364 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508364 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]