SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515207 LIMIT 1 [ RunTime:0.000287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515207 [ RunTime:0.003072s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027645,531859,629191,7735,506894,156774,743610,338957,1020483,468576,528169,853505,665098,518345,193589,501131,846716,864087,595611,800224,206594,298839,481739,272863,186846,706542,477878,530937,590317,188478,653912,729426,726400,339494,160574,931625,637198,458575,329433,139627,588165,685990,838645,369160,462929,535086,743849,678934,1040753,259331,954014,817614,947322,598126,325658,207138,696321,555123,253848,28574) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]