SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001472s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 551743 LIMIT 1 [ RunTime:0.001438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 551743 [ RunTime:0.002185s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415968,342273,176685,675076,1020862,20261,601596,899529,937895,404312,84152,169896,540595,862924,807940,547267,166493,47033,382415,714018,521268,112914,797539,385325,262375,111730,30707,25856,932213,638590,222908,92479,174802,1045491,435001,438249,920887,577734,316604,768058,816016,714708,517283,822766,511744,90513,884573,657360,229168,891944,830809,1001815,844993,869705,105675,87640,589593,592153,825572,978879) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 551743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 551743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]