SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001441s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 462861 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 462861 [ RunTime:0.001677s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193030,782868,855129,210668,1042469,125384,976830,725299,746395,118971,898613,660345,415015,547725,559397,946190,940362,490041,114984,134199,933621,428334,261311,14704,102490,409580,771659,1031754,479573,103771,1015346,811888,90177,483307,1655,487248,652611,625714,856097,543895,182619,1010162,547640,948318,534754,72710,35401,974811,255642,536472,130902,324693,269121,238735,742860,966585,1046557,852026,872558,80765) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 462861 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 462861 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]