SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 26133 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 26133 [ RunTime:0.001481s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (52230,165479,456628,440948,333538,1022760,95467,156482,660327,81610,1020476,216841,485436,267988,573613,787240,123575,911330,257206,712404,285804,385121,2271,77660,1016890,1002101,842956,643820,518093,157834,277642,376254,807127,826319,996914,249639,974944,120976,53355,310602,580602,290531,327631,373361,789709,813807,621977,951015,978441,999169,823475,630397,111322,983572,206,933812,665572,2964,342135,907989) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 26133 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 26133 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]