SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529281 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529281 [ RunTime:0.002149s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (303799,670339,768600,130446,764952,661091,1023109,271067,986893,102700,466500,429488,481472,315965,368117,720183,214327,729713,7602,638629,1017655,206467,807530,354059,838877,55086,534618,41090,297827,707762,433111,684851,697358,201692,574360,658768,722131,22398,562889,381501,549558,701301,439989,734857,813593,8585,506072,1008812,670889,134533,621501,412907,774399,906072,540515,341110,633153,684780,17657,1028015) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]