SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003608s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524300 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524300 [ RunTime:0.001593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (263812,856092,662872,1014380,407659,976627,435126,660715,811344,621819,94232,1009530,616322,824872,584911,1031035,250710,1048411,397647,423263,813753,363569,122616,978523,922215,242297,627540,650573,665152,306138,388365,253325,929236,632189,765258,672062,790878,364789,831858,458705,860382,461188,199628,271662,149579,71660,758047,981264,128324,678031,368531,130155,559625,1025627,209220,426580,205899,710501,325034,171351) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000846s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]