SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521354 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521354 [ RunTime:0.001683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801715,875400,659898,723843,635089,883444,997417,303729,418571,514156,20852,588494,875957,130210,494552,834634,422286,174254,49481,775689,710000,372500,236316,26402,49832,827288,668924,539383,570120,990392,797024,846071,575107,798859,1004872,608480,217014,735990,257332,433802,961898,384813,666017,852938,8864,286769,485350,678591,740965,239723,809960,17894,254144,734507,490840,511143,402719,237956,854813,242708) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521354 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521354 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]