SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 92010 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 92010 [ RunTime:0.002255s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (452251,182086,120533,511719,596025,821641,720403,369675,473000,712015,559783,1024,706989,516076,939801,149845,17508,8266,813910,233904,74012,699674,723311,319199,615344,553470,674027,768170,930778,691459,942805,275963,762759,56481,734583,284081,645311,347053,337763,557600,38061,112015,77720,324140,760123,933078,371961,1012393,13164,16979,275630,1013128,378763,525332,238957,691532,358608,195304,1021380,430172) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 92010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 92010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]