SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001433s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540925 LIMIT 1 [ RunTime:0.002234s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540925 [ RunTime:0.001622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599835,771217,514784,939650,574066,537420,678636,1045635,393551,774987,264801,948104,219984,886627,835124,610182,312253,770988,752135,762956,869518,55208,527163,876422,777434,5905,564507,92838,868949,252482,820264,1037838,843425,527373,447438,314438,750678,966848,782547,386256,606088,44461,266184,2201,137272,777619,358260,788906,878327,739985,937447,507725,1042519,936057,791546,1009582,876887,779309,384229,873299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540925 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540925 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]