SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555509 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555509 [ RunTime:0.002787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (737039,783172,860871,463312,729910,815673,794014,921447,173100,921563,945104,560788,361498,913477,498232,766488,511428,517248,1018464,896270,894886,412160,921271,70752,312374,208051,355274,141132,479414,627182,646180,520634,478901,860919,778255,782915,945848,904632,815355,250700,762630,515580,488825,10670,455598,446487,632196,976147,781904,223786,311613,96772,507606,679566,464721,191267,525378,690613,854030,464098) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]