SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503168 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503168 [ RunTime:0.001729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (689625,788539,127544,751796,78136,157207,290411,947309,757224,309058,1016815,106686,700241,510075,242741,837210,648687,17005,501574,1020168,295503,162284,265791,672643,346756,7321,680286,599704,774391,612562,396494,658320,163854,592928,135850,286053,136855,935017,575904,774243,793274,418236,246283,863119,1036422,18514,194611,550338,790549,724981,568123,603826,324131,628075,985789,543040,427011,709694,648749,194255) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503168 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503168 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]