SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201304 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201304 [ RunTime:0.002805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (57525,810686,211009,215049,44951,956084,976016,273228,312672,958710,959741,992218,309978,286158,978251,201592,1031358,417590,86022,65604,426747,679003,795743,52848,648067,249472,957777,292766,58488,462101,92448,202622,1011604,855494,417159,492821,616127,115304,913506,754648,896617,311091,1037976,511534,575432,734293,926060,744834,792563,99239,598846,468028,1046895,796857,681365,491727,336481,562594,444912,461007) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201304 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201304 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]