SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 178105 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 178105 [ RunTime:0.002002s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415641,972500,851240,401214,687063,978313,422242,643587,563292,867149,650439,971764,633207,609490,433604,837915,248980,378105,325559,10865,561445,232135,1015081,857712,572108,700787,167480,342970,44163,13598,230194,523425,487368,915764,610509,209080,211650,239004,31982,478105,23624,586006,776061,787568,319792,84459,819846,159171,64256,468221,21046,329220,130199,507795,996905,581918,204297,553664,123308,85600) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 178105 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 178105 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]