SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517544 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517544 [ RunTime:0.001662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (489623,150595,180372,749187,395407,270024,343336,303415,484832,975488,375640,671213,219678,755599,121380,895713,392909,161344,386222,729553,864625,705515,714760,201052,322238,849514,2176,985644,771100,365530,336404,353416,648210,684571,1021983,1017832,344626,258605,919758,1044529,724197,382886,238233,949879,125340,113676,853559,878812,288086,19777,78507,703434,983793,734677,155130,389444,218734,567917,350609,457917) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517544 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517544 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]