SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034810 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034810 [ RunTime:0.001691s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (262250,250475,886336,683145,1043203,503031,208557,361353,351496,876037,670282,210186,75628,61911,278972,773619,34878,314135,343194,789929,1021064,483885,152264,668033,977706,864171,249399,953258,589027,492006,248950,263432,896819,257336,967209,672684,829629,575448,736639,938086,205766,525697,530196,643002,920163,938561,490778,236308,698122,764722,392484,425695,63205,476357,99674,156075,92604,21657,566814,1022654) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001866s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]