SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403828 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403828 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191216,631029,461694,187289,465311,668983,307654,286631,877424,298985,476467,267988,741398,512412,140648,331894,85045,877465,755366,1007070,745807,553550,45663,732321,992806,249507,696645,839491,345545,83401,1014022,364827,737439,679229,860312,447832,8261,372447,973839,527927,176444,978516,920777,776061,277547,96545,790960,454225,48783,749605,689113,1010700,428400,744913,831292,713347,833168,1044653,534440,1016684) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403828 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403828 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]