SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005040s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 212679 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 212679 [ RunTime:0.002626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (626707,366412,969003,449219,414645,401595,200003,555309,7543,82007,945198,729328,684521,814145,538430,41824,668470,174019,374570,422304,120265,323933,7457,296600,986045,1003685,278121,426512,332138,976565,738778,43385,359224,152346,201348,928407,265884,791489,625096,463923,615511,950022,509162,906410,621173,569881,205812,466656,136893,483096,1018619,342161,122635,230451,388322,971718,805771,847302,169205,707287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 212679 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 212679 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]