SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 368273 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 368273 [ RunTime:0.002573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510594,619994,594019,730985,994475,726166,438121,116691,926710,844950,170535,687784,899375,686758,1043461,445116,779230,347520,844702,813598,378661,158079,324009,270307,100083,428478,488597,638368,530613,864950,415487,727972,312246,43288,583645,127711,746120,619732,1000333,238411,399842,964004,225089,694094,200682,85950,813116,485139,538020,324482,460059,816718,876775,924409,984689,3240,536333,772863,959301,908728) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 368273 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 368273 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]