SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000924s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 142313 LIMIT 1 [ RunTime:0.001088s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 142313 [ RunTime:0.002497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1733,439020,698765,397498,132378,263507,50326,141925,840674,435159,279668,130207,544949,329035,1029905,778489,18000,189115,214207,509831,902811,975562,222099,722527,190013,585363,957415,524893,952185,44643,997248,891444,409987,888655,188338,497261,706806,224919,579037,15383,512904,851561,494251,540817,593051,152647,312187,84876,236629,264182,364640,49710,851262,197506,396419,374577,649108,47379,491033,658092) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 142313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 142313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]