SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545026 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545026 [ RunTime:0.001783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180992,411471,155145,830406,9369,314689,44017,158944,434834,393911,602314,1017268,187480,580766,657851,414802,681793,872772,385900,550627,933547,540806,154640,449952,825482,1019437,183645,614711,881777,361837,982596,318358,59262,795604,4626,1017018,717858,346919,602852,534564,69281,366975,132326,203904,670267,117511,731308,1008632,219192,198170,61633,630450,632202,690108,1024558,836347,109595,481382,259821,134464) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545026 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545026 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]