SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406816 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406816 [ RunTime:0.001601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (558989,963728,312645,422085,519430,667045,761305,282769,78586,611203,971285,289949,1041601,29330,1046111,858830,858110,42436,161876,886301,940367,111535,228904,421738,851366,106480,306336,812046,701513,748178,1015709,588818,452423,186516,744736,1044949,648115,452902,367254,862888,648064,554486,641918,347555,1042925,707066,290855,84991,435391,818982,260100,147659,932136,515853,977224,797346,452072,661279,16671,575185) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000402s ]