SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488897 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488897 [ RunTime:0.001824s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111020,423284,792961,402710,748579,106008,248568,501154,408111,671676,1017595,499470,518099,336536,346466,602538,825823,645680,645699,908776,232045,271279,820670,831840,263941,830959,542831,665189,630768,715953,757036,960676,399872,41432,21652,311766,837761,441967,79646,777984,678433,117707,593439,894772,255404,32166,309015,372587,375100,327663,804301,869725,559749,1042279,9211,81260,447001,271139,199682,514846) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488897 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488897 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000693s ]