SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508411 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508411 [ RunTime:0.004464s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (795179,169081,809176,861816,425529,113133,779921,24067,466491,927575,987179,988404,603088,1019584,742907,463624,684558,947746,664109,942612,400466,971509,1023376,554978,226552,884153,734585,667716,159941,635604,215010,191041,634500,256847,226001,958789,179500,175319,772569,813461,136061,542161,944373,38429,266535,204532,57022,58537,676482,944194,975752,310066,351117,490156,357795,716569,209592,911197,642698,60043) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]