SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280940 LIMIT 1 [ RunTime:0.000453s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280940 [ RunTime:0.002199s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (768815,706913,862421,875397,666751,921282,436032,81233,399843,54640,205173,451309,906413,623579,459390,490824,61411,644096,889625,932476,497224,812162,932178,50635,61145,145910,630459,252376,866339,312226,453830,955103,542876,231600,644653,850176,899948,806839,834458,54715,1024660,926638,395272,798658,628996,827816,370627,772156,15326,969964,688418,721817,558382,845348,667528,292578,508880,152319,674437,194403) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000892s ]