SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003028s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193599 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193599 [ RunTime:0.001641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011335,705505,171308,67122,423849,139320,748703,768140,618914,157979,409790,407080,463735,594138,221225,30927,735723,481387,200339,1022799,200032,201334,988007,21899,198784,775401,66035,927983,337915,366176,712430,626693,833795,679696,958148,713527,455385,136391,528855,705640,744071,521905,465949,222357,1021239,893586,763790,93994,707469,292543,243225,254868,695658,12660,634563,49949,297567,813315,752392,782601) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]