SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039605 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039605 [ RunTime:0.002077s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (603167,244963,493746,994099,1035805,865017,651628,262802,176704,649720,688026,447346,679762,1258,202122,732565,54321,447804,709458,699623,1009088,75257,431760,821101,197700,508569,345514,140754,741938,241345,442561,831396,797314,1014385,262883,186120,97811,402536,536394,270710,573569,917250,640200,589498,191479,480024,322317,600312,149220,1025013,170572,105019,556976,1000596,966434,529119,591058,591104,78314,331096) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039605 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039605 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]