SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511083 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511083 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (621967,132865,947699,919617,886470,147965,1038939,821927,225460,475269,764920,540445,74372,868445,207170,878389,298403,919174,477431,480343,706831,851424,757680,28021,229825,773939,367549,621721,349214,1006020,626082,402958,1028785,737478,1005227,141317,708846,641322,486076,658339,398607,542994,87731,426426,599159,702324,128518,105960,946639,963851,557434,333596,813480,861049,681998,587893,441597,15242,913682,186490) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]