SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335487 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335487 [ RunTime:0.005859s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (384859,705353,148761,404265,64275,353780,820525,905656,420775,108260,231804,481640,103628,21798,463218,808995,1015663,876540,751873,320264,23309,888310,207280,992541,69136,404978,1041359,945533,162406,567845,530778,886800,104035,870372,566391,805740,810595,831577,695040,728127,134009,926378,937544,738841,75850,777543,71357,800963,571853,1027989,997548,12863,521482,99510,328588,1042179,991210,283050,796495,1038620) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335487 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335487 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]