SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001432s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482538 LIMIT 1 [ RunTime:0.002793s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482538 [ RunTime:0.001741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1015911,768212,411379,256270,1047054,281508,677255,893874,728529,819255,458914,87348,571708,556909,610566,351732,634652,440180,552829,758799,850783,308852,462402,1008297,780256,823250,43849,1032582,867713,58458,767511,509081,558852,347482,974433,40802,959544,621509,49281,928340,317133,901999,829534,419525,409927,754837,616693,740581,199159,677877,57493,215615,265666,148642,949382,914522,337414,78341,680798,969886) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482538 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482538 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001686s ]