SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518710 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518710 [ RunTime:0.002030s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002956,393656,183891,256938,113962,695529,941369,274200,720317,320383,823682,441618,62451,162240,810814,658875,15531,852807,681492,9225,128990,212147,346012,620067,931446,582997,473893,402437,651187,145937,652340,628470,750308,600056,201147,321678,596678,509317,1030694,293720,20143,1011280,411563,27446,439127,339611,454954,341613,117875,105228,572294,925703,257451,124267,577518,213700,812811,893785,883084,938713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000597s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]