SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318025 LIMIT 1 [ RunTime:0.001180s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318025 [ RunTime:0.001765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (146180,1034921,536094,717967,1030296,569727,297703,881003,362169,478686,493465,76422,993773,317615,883058,773251,855706,1005798,711694,256162,485139,988230,836433,525777,541747,888295,219024,499866,802876,421430,988729,707561,349992,892759,984061,165676,209196,619298,479280,399752,916367,577177,663657,441289,386478,867450,292963,930885,621843,864183,104853,954394,867038,1025525,456499,755289,931300,936574,955190,941325) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318025 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318025 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]