SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432911 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432911 [ RunTime:0.002294s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (21868,440658,395986,792653,150998,129998,866184,967563,690307,896624,70748,635364,187483,719985,920019,40280,144266,1019587,698370,343461,453655,883556,847067,207507,379413,953946,575386,303636,693113,360695,666211,439427,263797,408062,135423,999429,549331,970388,843809,755446,100110,545302,20971,601689,877276,515207,995018,999573,970246,1015027,208206,239013,798824,910207,313683,423558,481363,829724,113980,571147) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]