SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 205180 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 205180 [ RunTime:0.001900s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (986672,823659,5004,536699,1044232,724924,869363,244358,666404,975708,331392,897504,285069,674146,1023820,980865,606670,625797,749671,529722,272415,880486,816090,374899,643511,107322,940236,96037,481581,759723,1009849,593939,768363,82221,604569,810651,544085,384358,163991,686546,245063,1036850,139013,495,639008,314594,945480,162393,228372,195202,416327,511759,1028881,824449,928808,333331,584485,751877,886724,936471) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 205180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 205180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]