SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533391 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533391 [ RunTime:0.003429s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (885830,303739,1048127,489084,637691,575413,905679,401541,876550,197876,246086,489582,199929,785479,319394,291906,1006921,463376,168260,427947,225470,180582,481430,390139,712650,325470,279910,896173,860961,1006320,1023029,124248,372276,687423,349532,848097,345810,617632,889314,1533,992399,854013,839223,11707,107411,1029330,69965,233390,657294,879984,949181,865718,754878,176291,621107,900420,1043117,717572,617068,677076) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001752s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533391 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533391 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000739s ]