SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534117 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534117 [ RunTime:0.001702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140432,1446,232693,486633,786269,698896,756783,994343,421405,488552,426310,567324,608935,401828,975759,680541,805394,903249,816254,728645,923623,740220,194646,714416,293571,173810,329964,173268,128266,537743,139190,877240,172990,620966,865560,204794,869387,479692,747013,504208,758034,975829,888992,323342,180207,558485,307607,626235,586374,1038926,19042,982115,514780,792936,195937,51292,373271,511046,405701,332916) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000582s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]