SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318029 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318029 [ RunTime:0.001508s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (731463,788786,197039,589953,915004,283991,346909,307375,409798,809837,72180,849112,191971,521816,220474,619548,104079,971824,166577,821444,561126,544742,443965,255994,20582,569259,627311,199203,31386,760903,277370,344002,814600,310928,934634,386533,823869,1031997,69801,215371,93837,884572,768728,482516,259625,1033626,424437,115998,865944,999557,60570,125019,430429,580949,946991,687656,149568,900512,478900,1015508) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]