SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543716 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543716 [ RunTime:0.001628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113452,654936,929716,329023,570284,1032543,95952,634191,788791,337679,175346,330272,595964,170219,400220,742066,230687,932239,274487,285817,647685,129237,855689,649270,598924,1009127,399006,240800,883114,894874,1006728,511808,405237,157085,420948,773528,356900,561157,914454,417162,15501,656025,518377,1040673,789056,471059,1007566,977712,508956,32331,923728,300581,598457,775174,343829,958221,355693,549588,928231,264223) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543716 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543716 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]