SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 313584 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 313584 [ RunTime:0.001813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533954,323852,987662,535881,224641,173917,156898,131769,257920,376460,1042756,561977,732759,411859,537852,986608,282565,58313,323407,1016977,881937,780362,704712,774776,223726,370258,1011697,586822,765320,889572,215800,821496,756951,760072,305407,168069,68956,540862,15391,675827,50822,961516,978275,382510,391591,157570,727542,813281,196630,352176,1021997,405214,801732,669786,994179,29422,491842,502496,637442,23014) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 313584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 313584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]