SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5204 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5204 [ RunTime:0.001928s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022996,432034,10501,573585,902622,765091,892895,623069,109287,523448,845667,311321,132360,137781,81501,702644,369870,99225,111640,240305,246119,786686,456388,452927,778257,28109,135259,446459,472218,427636,902452,939683,942726,412424,682597,734687,262106,999471,507971,984635,504882,613441,697519,541997,854818,953084,789953,61804,883356,336858,673248,135339,239273,975246,393231,741255,700405,233107,400327,583569) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5204 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5204 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]