SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406510 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406510 [ RunTime:0.002052s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (561481,660606,260602,445839,768662,644934,282483,650998,558301,242083,781590,717541,454816,454499,14074,869724,975245,146569,1022793,278544,960910,267410,882837,947263,451016,222519,760278,485017,732449,22746,951218,380752,698042,360666,413940,629623,34554,592719,746268,604246,759561,353684,542187,681198,201402,653367,59347,124839,648545,696930,560918,436505,501288,953124,879391,619730,105858,426407,739674,844031) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]