SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001918s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 351620 LIMIT 1 [ RunTime:0.000514s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 351620 [ RunTime:0.003768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (507407,549427,96472,922920,421205,525767,117680,249031,265728,423259,302907,963202,668873,989300,116054,610052,23124,749013,163743,285026,236148,253850,770863,402350,423935,755881,701506,130554,743325,239878,573234,122579,838440,804506,1168,688911,182801,221006,218529,380955,208695,314150,707292,1029357,89083,992099,432459,893407,818355,691210,185017,924183,846690,876926,29854,368704,986240,707395,875929,358727) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001720s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 351620 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000692s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 351620 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000818s ]