SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039683 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039683 [ RunTime:0.002121s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (713417,621007,638095,678690,784932,276422,856183,851027,393978,487543,44232,719303,31453,37675,579229,5701,552511,272358,967465,141355,226998,628622,368467,341647,1025000,975862,826927,526517,914227,948524,186211,13870,933826,807523,995565,307730,579728,651930,703908,753754,383303,631312,910951,423591,19196,532936,816564,652255,55707,619586,729198,1017733,536108,902627,56119,917935,457389,254940,748019,490338) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]