SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001552s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532429 LIMIT 1 [ RunTime:0.000653s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532429 [ RunTime:0.001939s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1029945,907431,1028646,745140,663138,543978,559687,111285,329872,885262,808380,859586,503527,638280,863252,556092,77216,400845,56300,459960,802862,27437,53675,535132,598206,524639,288900,73816,84742,297581,27340,253231,736970,963821,137025,634295,225930,757751,177118,922483,163108,57923,745981,325825,220921,651651,731080,134894,984892,897194,802425,468832,523361,965001,175913,89941,1014716,244953,645725,797005) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532429 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000669s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532429 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000767s ]